SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE procedure dbo.DnnProduct_GetPortalByTab

@TabId int,
@HTTPAlias nvarchar(200)
 
as

select HTTPAlias
from dbo.DnnProduct_PortalAlias
inner join dbo.DnnProduct_Tabs on dbo.DnnProduct_PortalAlias.PortalId = dbo.DnnProduct_Tabs.PortalId
where  TabId = @TabId
and    HTTPAlias = @HTTPAlias 









GO
